home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ShareWare OnLine 2
/
ShareWare OnLine Volume 2 (CMS Software)(1993).iso
/
misc
/
ancestr.zip
/
ANCESTR.DCT
< prev
next >
Wrap
Text File
|
1992-01-11
|
4KB
|
73 lines
*/============================================================================
This is a data dictionary file for: ANCESTR geneological research program
FILE FIELD TYPE LEN DEC FUNCTION OR INDEX EXPRESSION
------------ ---------- - --- ---- ------------------------------------------/*
INDIV SERIAL N 6 0 Serial Code of Individual
INDIV SEX C 1 0 Sex of individual
INDIV LNAME C 20 0 Sir name of individual
INDIV FNAME1 C 20 0 Given name 1 of individual
INDIV FNAME2 C 20 0 Given name 2 of individual
INDIV FNAME3 C 20 0 Given name 3 of individual
INDIV TITLE C 20 0 Title of Individual
INDIV CCODE N 6 0 Family code as child
INDIV REFN C 10 0 Ancestral file reference number
INDIV NOTES M 10 0 Notes
INDIV BIRTD C 25 0 Birth Date
INDIV BIRTP1 C 20 0 Birth place word 1
INDIV BIRTP2 C 20 0 Birth place word 2
INDIV BIRTP3 C 20 0 Birth place word 3
INDIV BIRTP4 C 20 0 Birth place word 4
INDIV CHRD C 25 0 Birth Date
INDIV CHRP1 C 20 0 Birth place word 1
INDIV CHRP2 C 20 0 Birth place word 2
INDIV CHRP3 C 20 0 Birth place word 3
INDIV CHRP4 C 20 0 Birth place word 4
INDIV DEATD C 25 0 Birth Date
INDIV DEATP1 C 20 0 Birth place word 1
INDIV DEATP2 C 20 0 Birth place word 2
INDIV DEATP3 C 20 0 Birth place word 3
INDIV DEATP4 C 20 0 Birth place word 4
INDIV BURID C 25 0 Birth Date
INDIV BURIP1 C 20 0 Birth place word 1
INDIV BURIP2 C 20 0 Birth place word 2
INDIV BURIP3 C 20 0 Birth place word 3
INDIV BURIP4 C 20 0 Birth place word 4
INDIV BAPLD C 25 0 Baptismal Date
INDIV BAPLT C 5 0 Baptismal Temple
INDIV ENDLD C 25 0 Endowment Date
INDIV ENDLT C 5 0 Endowment Temple
INDIV SLGCD C 25 0 Sealed to Parrents Date
INDIV SLGCT C 5 0 Sealed To Parrentsl Temple
INDIV INDIV1 X SERIAL
INDIV INDIV2 X UPPER(LNAME) + UPPER(FNAME1) + UPPER(FNAME2) + UPPER(FNAME3)
INDIV INDIV3 X U UPPER(LNAME)
INDIV INDIV4 X SOUNDEX(LNAME)+IFF(EMPTY(birtd),DTOZ(chrd),DTOZ(birtd))+UPPER(FNAME1)+UPPER(FNAME2)+UPPER(FNAME3)
INDIV INDIV5 X FT_METAPH(LNAME)+IFF(EMPTY(birtd),DTOZ(chrd),DTOZ(birtd))+UPPER(FNAME1)+UPPER(FNAME2)+UPPER(FNAME3)
INDIV INDIV6 X STR(CCODE)+ IIF(EMPTY(birtd),DTOZ(chrd),DTOZ(birtd))
FAMIL SERIAL N 6 0 Family Serial Number
FAMIL HUSB N 6 0 Husband's Individual SerialNumber
FAMIL WIFE N 6 0 Wife's Individual Serial Number
FAMIL MARR C 25 0 Marriage Date
FAMIL MARRP1 C 20 0 Marriage Place Word 1
FAMIL MARRP2 C 20 0 Marriage Place Word 2
FAMIL MARRP3 C 20 0 Marriage Place Word 3
FAMIL MARRP4 C 20 0 Marriage Place Word 4
FAMIL SLGSD C 25 0 Sealing Date
FAMIL SLGST C 5 0 Temple Code
FAMIL DIV L 1 0 Divorce Status
FAMIL FAMIL1 X SERIAL
FAMIL FAMIL2 X STR(HUSB) + DTOZ(marr)
FAMIL FAMIL3 X STR(WIFE) + DTOZ(marr)
ANOTES SERIAL N 4 0 Note serial number
ANOTES DATE D 8 0 Date posted
ANOTES PNTD L 1 0 Previously printed flag
ANOTES NOTE M 10 0 Note text
ANOTES ANOTES1 X SERIAL
ANOTES ANOTES2 X DTOS(DATE)
INOTE SERIAL N 4 0 Note serial individual is related to
INOTE INDIV N 6 0 Individual serial number
INOTE INOTE1 X SERIAL
INOTE INOTE2 X INDIV